Excel 2016 - Modifying and Formatting Worksheets, Cell and Table Styles and Applying Themes
      The "Excel 2016 - Modifying and Formatting Worksheets, Cell and Table Styles and Applying Themes" lesson covers the following topics:
  • Modifying Worksheets
  • Cell and Table Styles
  • Formatting Worksheets
  • Applying Themes
      
      Modifying Worksheets      
      Upon successful completion you will be able to:

1. Hide and Unhide Columns and Rows;
2. Hide and Unhide Worksheets;
3. Group Worksheets;
4. Ungroup Worksheets;
5. Insert Multiple Rows and Columns;
6. Move Rows and Columns;
7. Open New Windows;
8. Arrange Multiple Windows;
9. Hide and Unhide Windows.

      
      Cell and Table Styles      
      Upon successful completion you will be able to:

1. Apply Cell Styles;
2. Remove Cell Styles;
3. Create Custom Cell Styles;
4. Apply Custom Cell Styles;
5. Modify Cell Styles;
6. Apply Table Styles;
7. Use the Total Row Option;
8. Name Tables;
9. Use Quick Analysis Tools.		      
      Formatting Worksheets      
      Upon successful completion you will be able to:

1. Apply and Remove Backgrounds;
2. Add Header and Footers;
3. Add Washout Images;
4. Resize Images;
5. Change Column Widths;
6. Change Row Heights;
7. Transpose Data.		      
      Applying Themes      
      Upon successful completion you will be able to:

1. Apply Themes;
2. Modify Themes;
3. Create Custom Themes;
4. Apply Effects;
5. Save Custom Themes;
6. Change the Default Theme.		      
This course can be purchased either individaully or as part of a package.
Single Training Course - Excel 2016 - Modifying and Formatting Worksheets, Cell and Table Styles and Applying Themes :
Program Training Courses - Microsoft Excel 2016 :
Office Suite Training Courses - Microsoft Office 2016 :
© 2017 Online Training Masters